/*
 Navicat Premium Data Transfer

 Source Server         : 47.98.251.224
 Source Server Type    : PostgreSQL
 Source Server Version : 150003 (150003)
 Source Host           : 47.98.251.224:5432
 Source Catalog        : kettle
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 150003 (150003)
 File Encoding         : 65001

 Date: 16/07/2023 13:57:31
*/


-- ----------------------------
-- Sequence structure for r_cluster_id_cluster_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_cluster_id_cluster_seq";
CREATE SEQUENCE "public"."r_cluster_id_cluster_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_cluster_id_cluster_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_cluster_slave_id_cluster_slave_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_cluster_slave_id_cluster_slave_seq";
CREATE SEQUENCE "public"."r_cluster_slave_id_cluster_slave_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_cluster_slave_id_cluster_slave_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_condition_id_condition_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_condition_id_condition_seq";
CREATE SEQUENCE "public"."r_condition_id_condition_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_condition_id_condition_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_database_attribute_id_database_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_database_attribute_id_database_attribute_seq";
CREATE SEQUENCE "public"."r_database_attribute_id_database_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_database_attribute_id_database_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_database_contype_id_database_contype_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_database_contype_id_database_contype_seq";
CREATE SEQUENCE "public"."r_database_contype_id_database_contype_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_database_contype_id_database_contype_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_database_id_database_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_database_id_database_seq";
CREATE SEQUENCE "public"."r_database_id_database_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_database_id_database_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_database_type_id_database_type_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_database_type_id_database_type_seq";
CREATE SEQUENCE "public"."r_database_type_id_database_type_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_database_type_id_database_type_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_dependency_id_dependency_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_dependency_id_dependency_seq";
CREATE SEQUENCE "public"."r_dependency_id_dependency_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_dependency_id_dependency_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_directory_id_directory_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_directory_id_directory_seq";
CREATE SEQUENCE "public"."r_directory_id_directory_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_directory_id_directory_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_element_attribute_id_element_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_element_attribute_id_element_attribute_seq";
CREATE SEQUENCE "public"."r_element_attribute_id_element_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_element_attribute_id_element_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_element_id_element_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_element_id_element_seq";
CREATE SEQUENCE "public"."r_element_id_element_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_element_id_element_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_element_type_id_element_type_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_element_type_id_element_type_seq";
CREATE SEQUENCE "public"."r_element_type_id_element_type_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_element_type_id_element_type_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_job_attribute_id_job_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_job_attribute_id_job_attribute_seq";
CREATE SEQUENCE "public"."r_job_attribute_id_job_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_job_attribute_id_job_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_job_hop_id_job_hop_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_job_hop_id_job_hop_seq";
CREATE SEQUENCE "public"."r_job_hop_id_job_hop_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_job_hop_id_job_hop_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_job_id_job_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_job_id_job_seq";
CREATE SEQUENCE "public"."r_job_id_job_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_job_id_job_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_job_lock_id_job_lock_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_job_lock_id_job_lock_seq";
CREATE SEQUENCE "public"."r_job_lock_id_job_lock_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_job_lock_id_job_lock_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_jobentry_attribute_id_jobentry_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_jobentry_attribute_id_jobentry_attribute_seq";
CREATE SEQUENCE "public"."r_jobentry_attribute_id_jobentry_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_jobentry_attribute_id_jobentry_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_jobentry_copy_id_jobentry_copy_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_jobentry_copy_id_jobentry_copy_seq";
CREATE SEQUENCE "public"."r_jobentry_copy_id_jobentry_copy_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_jobentry_copy_id_jobentry_copy_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_jobentry_id_jobentry_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_jobentry_id_jobentry_seq";
CREATE SEQUENCE "public"."r_jobentry_id_jobentry_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_jobentry_id_jobentry_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_jobentry_type_id_jobentry_type_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_jobentry_type_id_jobentry_type_seq";
CREATE SEQUENCE "public"."r_jobentry_type_id_jobentry_type_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_jobentry_type_id_jobentry_type_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_log_id_log_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_log_id_log_seq";
CREATE SEQUENCE "public"."r_log_id_log_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_log_id_log_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_loglevel_id_loglevel_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_loglevel_id_loglevel_seq";
CREATE SEQUENCE "public"."r_loglevel_id_loglevel_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_loglevel_id_loglevel_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_namespace_id_namespace_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_namespace_id_namespace_seq";
CREATE SEQUENCE "public"."r_namespace_id_namespace_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_namespace_id_namespace_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_note_id_note_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_note_id_note_seq";
CREATE SEQUENCE "public"."r_note_id_note_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_note_id_note_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_partition_id_partition_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_partition_id_partition_seq";
CREATE SEQUENCE "public"."r_partition_id_partition_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_partition_id_partition_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_partition_schema_id_partition_schema_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_partition_schema_id_partition_schema_seq";
CREATE SEQUENCE "public"."r_partition_schema_id_partition_schema_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_partition_schema_id_partition_schema_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_repository_log_id_repository_log_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_repository_log_id_repository_log_seq";
CREATE SEQUENCE "public"."r_repository_log_id_repository_log_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_repository_log_id_repository_log_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_slave_id_slave_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_slave_id_slave_seq";
CREATE SEQUENCE "public"."r_slave_id_slave_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_slave_id_slave_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_step_attribute_id_step_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_step_attribute_id_step_attribute_seq";
CREATE SEQUENCE "public"."r_step_attribute_id_step_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_step_attribute_id_step_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_step_id_step_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_step_id_step_seq";
CREATE SEQUENCE "public"."r_step_id_step_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_step_id_step_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_step_type_id_step_type_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_step_type_id_step_type_seq";
CREATE SEQUENCE "public"."r_step_type_id_step_type_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_step_type_id_step_type_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_attribute_id_trans_attribute_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_attribute_id_trans_attribute_seq";
CREATE SEQUENCE "public"."r_trans_attribute_id_trans_attribute_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_attribute_id_trans_attribute_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_cluster_id_trans_cluster_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_cluster_id_trans_cluster_seq";
CREATE SEQUENCE "public"."r_trans_cluster_id_trans_cluster_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_cluster_id_trans_cluster_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_hop_id_trans_hop_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_hop_id_trans_hop_seq";
CREATE SEQUENCE "public"."r_trans_hop_id_trans_hop_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_hop_id_trans_hop_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_lock_id_trans_lock_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_lock_id_trans_lock_seq";
CREATE SEQUENCE "public"."r_trans_lock_id_trans_lock_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_lock_id_trans_lock_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_partition_schema_id_trans_partition_schema_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_partition_schema_id_trans_partition_schema_seq";
CREATE SEQUENCE "public"."r_trans_partition_schema_id_trans_partition_schema_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_partition_schema_id_trans_partition_schema_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_trans_slave_id_trans_slave_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_trans_slave_id_trans_slave_seq";
CREATE SEQUENCE "public"."r_trans_slave_id_trans_slave_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_trans_slave_id_trans_slave_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_transformation_id_transformation_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_transformation_id_transformation_seq";
CREATE SEQUENCE "public"."r_transformation_id_transformation_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_transformation_id_transformation_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_user_id_user_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_user_id_user_seq";
CREATE SEQUENCE "public"."r_user_id_user_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_user_id_user_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_value_id_value_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_value_id_value_seq";
CREATE SEQUENCE "public"."r_value_id_value_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_value_id_value_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for r_version_id_version_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."r_version_id_version_seq";
CREATE SEQUENCE "public"."r_version_id_version_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER SEQUENCE "public"."r_version_id_version_seq" OWNER TO "postgresql";

-- ----------------------------
-- Sequence structure for test_product_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."test_product_id_seq";
CREATE SEQUENCE "public"."test_product_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;
ALTER SEQUENCE "public"."test_product_id_seq" OWNER TO "postgresql";

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_blob_triggers";
CREATE TABLE "public"."qrtz_blob_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "blob_data" bytea
)
;
ALTER TABLE "public"."qrtz_blob_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_calendars";
CREATE TABLE "public"."qrtz_calendars" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "calendar_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "calendar" bytea NOT NULL
)
;
ALTER TABLE "public"."qrtz_calendars" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_cron_triggers";
CREATE TABLE "public"."qrtz_cron_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "cron_expression" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "time_zone_id" varchar(80) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."qrtz_cron_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_fired_triggers";
CREATE TABLE "public"."qrtz_fired_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "entry_id" varchar(95) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "instance_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "fired_time" int8 NOT NULL,
  "sched_time" int8 NOT NULL,
  "priority" int4 NOT NULL,
  "state" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "job_name" varchar(200) COLLATE "pg_catalog"."default",
  "job_group" varchar(200) COLLATE "pg_catalog"."default",
  "is_nonconcurrent" bool,
  "requests_recovery" bool
)
;
ALTER TABLE "public"."qrtz_fired_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_job_details";
CREATE TABLE "public"."qrtz_job_details" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "job_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "job_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "description" varchar(250) COLLATE "pg_catalog"."default",
  "job_class_name" varchar(250) COLLATE "pg_catalog"."default" NOT NULL,
  "is_durable" bool NOT NULL,
  "is_nonconcurrent" bool NOT NULL,
  "is_update_data" bool NOT NULL,
  "requests_recovery" bool NOT NULL,
  "job_data" bytea
)
;
ALTER TABLE "public"."qrtz_job_details" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_locks";
CREATE TABLE "public"."qrtz_locks" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "lock_name" varchar(40) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "public"."qrtz_locks" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_paused_trigger_grps";
CREATE TABLE "public"."qrtz_paused_trigger_grps" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "public"."qrtz_paused_trigger_grps" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_scheduler_state";
CREATE TABLE "public"."qrtz_scheduler_state" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "instance_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "last_checkin_time" int8 NOT NULL,
  "checkin_interval" int8 NOT NULL
)
;
ALTER TABLE "public"."qrtz_scheduler_state" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_simple_triggers";
CREATE TABLE "public"."qrtz_simple_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "repeat_count" int8 NOT NULL,
  "repeat_interval" int8 NOT NULL,
  "times_triggered" int8 NOT NULL
)
;
ALTER TABLE "public"."qrtz_simple_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_simprop_triggers";
CREATE TABLE "public"."qrtz_simprop_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "str_prop_1" varchar(512) COLLATE "pg_catalog"."default",
  "str_prop_2" varchar(512) COLLATE "pg_catalog"."default",
  "str_prop_3" varchar(512) COLLATE "pg_catalog"."default",
  "int_prop_1" int4,
  "int_prop_2" int4,
  "long_prop_1" int8,
  "long_prop_2" int8,
  "dec_prop_1" numeric(13,4),
  "dec_prop_2" numeric(13,4),
  "bool_prop_1" bool,
  "bool_prop_2" bool
)
;
ALTER TABLE "public"."qrtz_simprop_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS "public"."qrtz_triggers";
CREATE TABLE "public"."qrtz_triggers" (
  "sched_name" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "job_name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "job_group" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "description" varchar(250) COLLATE "pg_catalog"."default",
  "next_fire_time" int8,
  "prev_fire_time" int8,
  "priority" int4,
  "trigger_state" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "trigger_type" varchar(8) COLLATE "pg_catalog"."default" NOT NULL,
  "start_time" int8 NOT NULL,
  "end_time" int8,
  "calendar_name" varchar(200) COLLATE "pg_catalog"."default",
  "misfire_instr" int2,
  "job_data" bytea
)
;
ALTER TABLE "public"."qrtz_triggers" OWNER TO "postgresql";

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_cluster
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_cluster";
CREATE TABLE "public"."r_cluster" (
  "id_cluster" int8 NOT NULL DEFAULT nextval('r_cluster_id_cluster_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "base_port" varchar(255) COLLATE "pg_catalog"."default",
  "sockets_buffer_size" varchar(255) COLLATE "pg_catalog"."default",
  "sockets_flush_interval" varchar(255) COLLATE "pg_catalog"."default",
  "sockets_compressed" bool,
  "dynamic_cluster" bool
)
;
ALTER TABLE "public"."r_cluster" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_cluster
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_cluster_slave
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_cluster_slave";
CREATE TABLE "public"."r_cluster_slave" (
  "id_cluster_slave" int8 NOT NULL DEFAULT nextval('r_cluster_slave_id_cluster_slave_seq'::regclass),
  "id_cluster" int4,
  "id_slave" int4
)
;
ALTER TABLE "public"."r_cluster_slave" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_cluster_slave
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_condition
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_condition";
CREATE TABLE "public"."r_condition" (
  "id_condition" int8 NOT NULL DEFAULT nextval('r_condition_id_condition_seq'::regclass),
  "id_condition_parent" int4,
  "negated" bool,
  "OPERATOR" varchar(255) COLLATE "pg_catalog"."default",
  "left_name" varchar(255) COLLATE "pg_catalog"."default",
  "condition_function" varchar(255) COLLATE "pg_catalog"."default",
  "right_name" varchar(255) COLLATE "pg_catalog"."default",
  "id_value_right" int4
)
;
ALTER TABLE "public"."r_condition" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_condition
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_database
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_database";
CREATE TABLE "public"."r_database" (
  "id_database" int8 NOT NULL DEFAULT nextval('r_database_id_database_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "id_database_type" int4,
  "id_database_contype" int4,
  "host_name" varchar(255) COLLATE "pg_catalog"."default",
  "database_name" varchar(2000000) COLLATE "pg_catalog"."default",
  "port" int4,
  "username" varchar(255) COLLATE "pg_catalog"."default",
  "PASSWORD" varchar(255) COLLATE "pg_catalog"."default",
  "servername" varchar(255) COLLATE "pg_catalog"."default",
  "data_tbs" varchar(255) COLLATE "pg_catalog"."default",
  "index_tbs" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_database" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_database_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_database_attribute";
CREATE TABLE "public"."r_database_attribute" (
  "id_database_attribute" int8 NOT NULL DEFAULT nextval('r_database_attribute_id_database_attribute_seq'::regclass),
  "id_database" int4,
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_database_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_database_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_database_contype
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_database_contype";
CREATE TABLE "public"."r_database_contype" (
  "id_database_contype" int8 NOT NULL DEFAULT nextval('r_database_contype_id_database_contype_seq'::regclass),
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_database_contype" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_database_contype
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_database_type
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_database_type";
CREATE TABLE "public"."r_database_type" (
  "id_database_type" int8 NOT NULL DEFAULT nextval('r_database_type_id_database_type_seq'::regclass),
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_database_type" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_database_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_dependency
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_dependency";
CREATE TABLE "public"."r_dependency" (
  "id_dependency" int8 NOT NULL DEFAULT nextval('r_dependency_id_dependency_seq'::regclass),
  "id_transformation" int4,
  "id_database" int4,
  "TABLE_NAME" varchar(255) COLLATE "pg_catalog"."default",
  "field_name" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_dependency" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_dependency
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_directory
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_directory";
CREATE TABLE "public"."r_directory" (
  "id_directory" int8 NOT NULL DEFAULT nextval('r_directory_id_directory_seq'::regclass),
  "id_directory_parent" int4,
  "directory_name" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_directory" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_directory
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_element
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_element";
CREATE TABLE "public"."r_element" (
  "id_element" int8 NOT NULL DEFAULT nextval('r_element_id_element_seq'::regclass),
  "id_element_type" int4,
  "NAME" text COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_element" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_element
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_element_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_element_attribute";
CREATE TABLE "public"."r_element_attribute" (
  "id_element_attribute" int8 NOT NULL DEFAULT nextval('r_element_attribute_id_element_attribute_seq'::regclass),
  "id_element" int4,
  "id_element_attribute_parent" int4,
  "attr_key" varchar(255) COLLATE "pg_catalog"."default",
  "attr_value" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_element_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_element_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_element_type
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_element_type";
CREATE TABLE "public"."r_element_type" (
  "id_element_type" int8 NOT NULL DEFAULT nextval('r_element_type_id_element_type_seq'::regclass),
  "id_namespace" int4,
  "NAME" text COLLATE "pg_catalog"."default",
  "description" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_element_type" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_element_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_job
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_job";
CREATE TABLE "public"."r_job" (
  "id_job" int8 NOT NULL DEFAULT nextval('r_job_id_job_seq'::regclass),
  "id_directory" int4,
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(2000000) COLLATE "pg_catalog"."default",
  "extended_description" varchar(2000000) COLLATE "pg_catalog"."default",
  "job_version" varchar(255) COLLATE "pg_catalog"."default",
  "job_status" int4,
  "id_database_log" int4,
  "table_name_log" varchar(255) COLLATE "pg_catalog"."default",
  "created_user" varchar(255) COLLATE "pg_catalog"."default",
  "created_date" timestamp(6),
  "modified_user" varchar(255) COLLATE "pg_catalog"."default",
  "modified_date" timestamp(6),
  "use_batch_id" bool,
  "pass_batch_id" bool,
  "use_logfield" bool,
  "shared_file" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_job" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_job_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_job_attribute";
CREATE TABLE "public"."r_job_attribute" (
  "id_job_attribute" int8 NOT NULL DEFAULT nextval('r_job_attribute_id_job_attribute_seq'::regclass),
  "id_job" int4,
  "nr" int4,
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "value_num" int8,
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_job_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_job_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_job_hop
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_job_hop";
CREATE TABLE "public"."r_job_hop" (
  "id_job_hop" int8 NOT NULL DEFAULT nextval('r_job_hop_id_job_hop_seq'::regclass),
  "id_job" int4,
  "id_jobentry_copy_from" int4,
  "id_jobentry_copy_to" int4,
  "enabled" bool,
  "evaluation" bool,
  "unconditional" bool
)
;
ALTER TABLE "public"."r_job_hop" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_job_hop
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_job_lock
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_job_lock";
CREATE TABLE "public"."r_job_lock" (
  "id_job_lock" int8 NOT NULL DEFAULT nextval('r_job_lock_id_job_lock_seq'::regclass),
  "id_job" int4,
  "id_user" int4,
  "lock_message" varchar(2000000) COLLATE "pg_catalog"."default",
  "lock_date" timestamp(6)
)
;
ALTER TABLE "public"."r_job_lock" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_job_lock
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_job_note
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_job_note";
CREATE TABLE "public"."r_job_note" (
  "id_job" int4,
  "id_note" int4
)
;
ALTER TABLE "public"."r_job_note" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_job_note
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_jobentry
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_jobentry";
CREATE TABLE "public"."r_jobentry" (
  "id_jobentry" int8 NOT NULL DEFAULT nextval('r_jobentry_id_jobentry_seq'::regclass),
  "id_job" int4,
  "id_jobentry_type" int4,
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_jobentry" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_jobentry
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_jobentry_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_jobentry_attribute";
CREATE TABLE "public"."r_jobentry_attribute" (
  "id_jobentry_attribute" int8 NOT NULL DEFAULT nextval('r_jobentry_attribute_id_jobentry_attribute_seq'::regclass),
  "id_job" int4,
  "id_jobentry" int4,
  "nr" int4,
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default",
  "value_num" numeric(15,2)
)
;
ALTER TABLE "public"."r_jobentry_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_jobentry_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_jobentry_copy
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_jobentry_copy";
CREATE TABLE "public"."r_jobentry_copy" (
  "id_jobentry_copy" int8 NOT NULL DEFAULT nextval('r_jobentry_copy_id_jobentry_copy_seq'::regclass),
  "id_jobentry" int4,
  "id_job" int4,
  "id_jobentry_type" int4,
  "nr" int2,
  "gui_location_x" int4,
  "gui_location_y" int4,
  "gui_draw" bool,
  "parallel" bool
)
;
ALTER TABLE "public"."r_jobentry_copy" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_jobentry_copy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_jobentry_database
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_jobentry_database";
CREATE TABLE "public"."r_jobentry_database" (
  "id_job" int4,
  "id_jobentry" int4,
  "id_database" int4
)
;
ALTER TABLE "public"."r_jobentry_database" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_jobentry_database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_jobentry_type
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_jobentry_type";
CREATE TABLE "public"."r_jobentry_type" (
  "id_jobentry_type" int8 NOT NULL DEFAULT nextval('r_jobentry_type_id_jobentry_type_seq'::regclass),
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_jobentry_type" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_jobentry_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_log
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_log";
CREATE TABLE "public"."r_log" (
  "id_log" int8 NOT NULL DEFAULT nextval('r_log_id_log_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "id_loglevel" int4,
  "logtype" varchar(255) COLLATE "pg_catalog"."default",
  "filename" varchar(255) COLLATE "pg_catalog"."default",
  "fileextention" varchar(255) COLLATE "pg_catalog"."default",
  "add_date" bool,
  "add_time" bool,
  "id_database_log" int4,
  "table_name_log" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_log" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_loglevel
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_loglevel";
CREATE TABLE "public"."r_loglevel" (
  "id_loglevel" int8 NOT NULL DEFAULT nextval('r_loglevel_id_loglevel_seq'::regclass),
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_loglevel" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_loglevel
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_namespace
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_namespace";
CREATE TABLE "public"."r_namespace" (
  "id_namespace" int8 NOT NULL DEFAULT nextval('r_namespace_id_namespace_seq'::regclass),
  "NAME" text COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_namespace" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_namespace
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_note
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_note";
CREATE TABLE "public"."r_note" (
  "id_note" int8 NOT NULL DEFAULT nextval('r_note_id_note_seq'::regclass),
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default",
  "gui_location_x" int4,
  "gui_location_y" int4,
  "gui_location_width" int4,
  "gui_location_height" int4,
  "font_name" varchar(2000000) COLLATE "pg_catalog"."default",
  "font_size" int4,
  "font_bold" bool,
  "font_italic" bool,
  "font_color_red" int4,
  "font_color_green" int4,
  "font_color_blue" int4,
  "font_back_ground_color_red" int4,
  "font_back_ground_color_green" int4,
  "font_back_ground_color_blue" int4,
  "font_border_color_red" int4,
  "font_border_color_green" int4,
  "font_border_color_blue" int4,
  "draw_shadow" bool
)
;
ALTER TABLE "public"."r_note" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_note
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_partition
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_partition";
CREATE TABLE "public"."r_partition" (
  "id_partition" int8 NOT NULL DEFAULT nextval('r_partition_id_partition_seq'::regclass),
  "id_partition_schema" int4,
  "partition_id" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_partition" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_partition
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_partition_schema
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_partition_schema";
CREATE TABLE "public"."r_partition_schema" (
  "id_partition_schema" int8 NOT NULL DEFAULT nextval('r_partition_schema_id_partition_schema_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "dynamic_definition" bool,
  "partitions_per_slave" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_partition_schema" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_partition_schema
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_repository_log
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_repository_log";
CREATE TABLE "public"."r_repository_log" (
  "id_repository_log" int8 NOT NULL DEFAULT nextval('r_repository_log_id_repository_log_seq'::regclass),
  "rep_version" varchar(255) COLLATE "pg_catalog"."default",
  "log_date" timestamp(6),
  "log_user" varchar(255) COLLATE "pg_catalog"."default",
  "operation_desc" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_repository_log" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_repository_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_slave
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_slave";
CREATE TABLE "public"."r_slave" (
  "id_slave" int8 NOT NULL DEFAULT nextval('r_slave_id_slave_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "host_name" varchar(255) COLLATE "pg_catalog"."default",
  "port" varchar(255) COLLATE "pg_catalog"."default",
  "web_app_name" varchar(255) COLLATE "pg_catalog"."default",
  "username" varchar(255) COLLATE "pg_catalog"."default",
  "PASSWORD" varchar(255) COLLATE "pg_catalog"."default",
  "proxy_host_name" varchar(255) COLLATE "pg_catalog"."default",
  "proxy_port" varchar(255) COLLATE "pg_catalog"."default",
  "non_proxy_hosts" varchar(255) COLLATE "pg_catalog"."default",
  "master" bool
)
;
ALTER TABLE "public"."r_slave" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_slave
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_step
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_step";
CREATE TABLE "public"."r_step" (
  "id_step" int8 NOT NULL DEFAULT nextval('r_step_id_step_seq'::regclass),
  "id_transformation" int4,
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(2000000) COLLATE "pg_catalog"."default",
  "id_step_type" int4,
  "distribute" bool,
  "copies" int2,
  "gui_location_x" int4,
  "gui_location_y" int4,
  "gui_draw" bool,
  "copies_string" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_step" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_step
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_step_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_step_attribute";
CREATE TABLE "public"."r_step_attribute" (
  "id_step_attribute" int8 NOT NULL DEFAULT nextval('r_step_attribute_id_step_attribute_seq'::regclass),
  "id_transformation" int4,
  "id_step" int4,
  "nr" int4,
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "value_num" int8,
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_step_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_step_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_step_database
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_step_database";
CREATE TABLE "public"."r_step_database" (
  "id_transformation" int4,
  "id_step" int4,
  "id_database" int4
)
;
ALTER TABLE "public"."r_step_database" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_step_database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_step_type
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_step_type";
CREATE TABLE "public"."r_step_type" (
  "id_step_type" int8 NOT NULL DEFAULT nextval('r_step_type_id_step_type_seq'::regclass),
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default",
  "helptext" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_step_type" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_step_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_attribute
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_attribute";
CREATE TABLE "public"."r_trans_attribute" (
  "id_trans_attribute" int8 NOT NULL DEFAULT nextval('r_trans_attribute_id_trans_attribute_seq'::regclass),
  "id_transformation" int4,
  "nr" int4,
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "value_num" int8,
  "value_str" varchar(2000000) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."r_trans_attribute" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_cluster
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_cluster";
CREATE TABLE "public"."r_trans_cluster" (
  "id_trans_cluster" int8 NOT NULL DEFAULT nextval('r_trans_cluster_id_trans_cluster_seq'::regclass),
  "id_transformation" int4,
  "id_cluster" int4
)
;
ALTER TABLE "public"."r_trans_cluster" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_cluster
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_hop
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_hop";
CREATE TABLE "public"."r_trans_hop" (
  "id_trans_hop" int8 NOT NULL DEFAULT nextval('r_trans_hop_id_trans_hop_seq'::regclass),
  "id_transformation" int4,
  "id_step_from" int4,
  "id_step_to" int4,
  "enabled" bool
)
;
ALTER TABLE "public"."r_trans_hop" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_hop
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_lock
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_lock";
CREATE TABLE "public"."r_trans_lock" (
  "id_trans_lock" int8 NOT NULL DEFAULT nextval('r_trans_lock_id_trans_lock_seq'::regclass),
  "id_transformation" int4,
  "id_user" int4,
  "lock_message" varchar(2000000) COLLATE "pg_catalog"."default",
  "lock_date" timestamp(6)
)
;
ALTER TABLE "public"."r_trans_lock" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_lock
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_note
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_note";
CREATE TABLE "public"."r_trans_note" (
  "id_transformation" int4,
  "id_note" int4
)
;
ALTER TABLE "public"."r_trans_note" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_note
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_partition_schema
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_partition_schema";
CREATE TABLE "public"."r_trans_partition_schema" (
  "id_trans_partition_schema" int8 NOT NULL DEFAULT nextval('r_trans_partition_schema_id_trans_partition_schema_seq'::regclass),
  "id_transformation" int4,
  "id_partition_schema" int4
)
;
ALTER TABLE "public"."r_trans_partition_schema" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_partition_schema
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_slave
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_slave";
CREATE TABLE "public"."r_trans_slave" (
  "id_trans_slave" int8 NOT NULL DEFAULT nextval('r_trans_slave_id_trans_slave_seq'::regclass),
  "id_transformation" int4,
  "id_slave" int4
)
;
ALTER TABLE "public"."r_trans_slave" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_slave
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_trans_step_condition
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_trans_step_condition";
CREATE TABLE "public"."r_trans_step_condition" (
  "id_transformation" int4,
  "id_step" int4,
  "id_condition" int4
)
;
ALTER TABLE "public"."r_trans_step_condition" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_trans_step_condition
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_transformation
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_transformation";
CREATE TABLE "public"."r_transformation" (
  "id_transformation" int8 NOT NULL DEFAULT nextval('r_transformation_id_transformation_seq'::regclass),
  "id_directory" int4,
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(2000000) COLLATE "pg_catalog"."default",
  "extended_description" varchar(2000000) COLLATE "pg_catalog"."default",
  "trans_version" varchar(255) COLLATE "pg_catalog"."default",
  "trans_status" int4,
  "id_step_read" int4,
  "id_step_write" int4,
  "id_step_input" int4,
  "id_step_output" int4,
  "id_step_update" int4,
  "id_database_log" int4,
  "table_name_log" varchar(255) COLLATE "pg_catalog"."default",
  "use_batchid" bool,
  "use_logfield" bool,
  "id_database_maxdate" int4,
  "table_name_maxdate" varchar(255) COLLATE "pg_catalog"."default",
  "field_name_maxdate" varchar(255) COLLATE "pg_catalog"."default",
  "created_user" varchar(255) COLLATE "pg_catalog"."default",
  "created_date" timestamp(6),
  "modified_user" varchar(255) COLLATE "pg_catalog"."default",
  "modified_date" timestamp(6),
  "size_rowset" int4,
  "offset_maxdate" numeric(14,2),
  "diff_maxdate" numeric(14,2),
  "offset_maxdate_ktl" numeric(14,2)
)
;
ALTER TABLE "public"."r_transformation" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_transformation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_user
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_user";
CREATE TABLE "public"."r_user" (
  "id_user" int8 NOT NULL DEFAULT nextval('r_user_id_user_seq'::regclass),
  "LOGIN" varchar(255) COLLATE "pg_catalog"."default",
  "PASSWORD" varchar(255) COLLATE "pg_catalog"."default",
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "description" varchar(255) COLLATE "pg_catalog"."default",
  "enabled" bool
)
;
ALTER TABLE "public"."r_user" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_value
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_value";
CREATE TABLE "public"."r_value" (
  "id_value" int8 NOT NULL DEFAULT nextval('r_value_id_value_seq'::regclass),
  "NAME" varchar(255) COLLATE "pg_catalog"."default",
  "value_type" varchar(255) COLLATE "pg_catalog"."default",
  "value_str" varchar(255) COLLATE "pg_catalog"."default",
  "is_null" bool
)
;
ALTER TABLE "public"."r_value" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_value
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for r_version
-- ----------------------------
DROP TABLE IF EXISTS "public"."r_version";
CREATE TABLE "public"."r_version" (
  "id_version" int8 NOT NULL DEFAULT nextval('r_version_id_version_seq'::regclass),
  "major_version" int2,
  "minor_version" int2,
  "upgrade_date" timestamp(6),
  "is_upgrade" bool
)
;
ALTER TABLE "public"."r_version" OWNER TO "postgresql";

-- ----------------------------
-- Records of r_version
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for task_info
-- ----------------------------
DROP TABLE IF EXISTS "public"."task_info";
CREATE TABLE "public"."task_info" (
  "task_id" int8 NOT NULL,
  "task_code" varchar(20) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "cron_expression" varchar(20) COLLATE "pg_catalog"."default",
  "fail" int4 DEFAULT 0,
  "full_class_name" varchar(200) COLLATE "pg_catalog"."default",
  "job_data_map" varchar(200) COLLATE "pg_catalog"."default",
  "job_group_name" varchar(100) COLLATE "pg_catalog"."default",
  "job_name" varchar(100) COLLATE "pg_catalog"."default",
  "task_name" varchar(100) COLLATE "pg_catalog"."default",
  "task_state" int4 DEFAULT 1,
  "success" int4 DEFAULT 0,
  "trigger_group_name" varchar(100) COLLATE "pg_catalog"."default",
  "trigger_name" varchar(100) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "file_id" varchar(20) COLLATE "pg_catalog"."default",
  "version" int4 DEFAULT 0,
  "deleted" int4 DEFAULT 1,
  "task_type" int4 DEFAULT 1,
  "file_type" int4 DEFAULT 2
)
;
ALTER TABLE "public"."task_info" OWNER TO "postgresql";
COMMENT ON COLUMN "public"."task_info"."task_id" IS '数据库主键（雪花Id）';
COMMENT ON COLUMN "public"."task_info"."task_code" IS '任务code标识';
COMMENT ON COLUMN "public"."task_info"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."task_info"."cron_expression" IS 'cron表达式';
COMMENT ON COLUMN "public"."task_info"."fail" IS '失败次数';
COMMENT ON COLUMN "public"."task_info"."full_class_name" IS '任务执行类 全类名，Job类';
COMMENT ON COLUMN "public"."task_info"."job_data_map" IS 'jobDataMap json格式';
COMMENT ON COLUMN "public"."task_info"."job_group_name" IS ' job组名称';
COMMENT ON COLUMN "public"."task_info"."job_name" IS 'job 名称';
COMMENT ON COLUMN "public"."task_info"."task_name" IS '任务名称';
COMMENT ON COLUMN "public"."task_info"."task_state" IS '是否启用 1-启用 0-禁用';
COMMENT ON COLUMN "public"."task_info"."success" IS '成功执行次数';
COMMENT ON COLUMN "public"."task_info"."trigger_group_name" IS '触发器组名称';
COMMENT ON COLUMN "public"."task_info"."trigger_name" IS '触发器名称';
COMMENT ON COLUMN "public"."task_info"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."task_info"."file_id" IS '文件Id';
COMMENT ON COLUMN "public"."task_info"."version" IS '乐观锁版本号';
COMMENT ON COLUMN "public"."task_info"."deleted" IS '逻辑删除：0删除 1存在';
COMMENT ON COLUMN "public"."task_info"."task_type" IS '任务类型：1一次性任务 2周期性任务';
COMMENT ON COLUMN "public"."task_info"."file_type" IS '文件类型：1作业 2转换';
COMMENT ON TABLE "public"."task_info" IS '任务信息表';

-- ----------------------------
-- Records of task_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for task_log
-- ----------------------------
DROP TABLE IF EXISTS "public"."task_log";
CREATE TABLE "public"."task_log" (
  "log_id" int8 NOT NULL,
  "task_id" int8,
  "activate_time" timestamp(6),
  "consumer_time" int8,
  "execute_result" int4,
  "remark" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."task_log" OWNER TO "postgresql";
COMMENT ON COLUMN "public"."task_log"."log_id" IS '主键';
COMMENT ON COLUMN "public"."task_log"."task_id" IS '任务ID';
COMMENT ON COLUMN "public"."task_log"."activate_time" IS '激活时间';
COMMENT ON COLUMN "public"."task_log"."consumer_time" IS '耗时';
COMMENT ON COLUMN "public"."task_log"."execute_result" IS '执行结果：
1： 成功
0： 失败';
COMMENT ON COLUMN "public"."task_log"."remark" IS '备注';
COMMENT ON TABLE "public"."task_log" IS '任务执行日志';

-- ----------------------------
-- Records of task_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for test_product
-- ----------------------------
DROP TABLE IF EXISTS "public"."test_product";
CREATE TABLE "public"."test_product" (
  "id" int4 NOT NULL DEFAULT nextval('test_product_id_seq'::regclass),
  "product_type" varchar COLLATE "pg_catalog"."default",
  "product_id" varchar COLLATE "pg_catalog"."default",
  "strategy_id" varchar COLLATE "pg_catalog"."default",
  "style" varchar COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."test_product" OWNER TO "postgresql";

-- ----------------------------
-- Records of test_product
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_cluster_id_cluster_seq"
OWNED BY "public"."r_cluster"."id_cluster";
SELECT setval('"public"."r_cluster_id_cluster_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_cluster_slave_id_cluster_slave_seq"
OWNED BY "public"."r_cluster_slave"."id_cluster_slave";
SELECT setval('"public"."r_cluster_slave_id_cluster_slave_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_condition_id_condition_seq"
OWNED BY "public"."r_condition"."id_condition";
SELECT setval('"public"."r_condition_id_condition_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_database_attribute_id_database_attribute_seq"
OWNED BY "public"."r_database_attribute"."id_database_attribute";
SELECT setval('"public"."r_database_attribute_id_database_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_database_contype_id_database_contype_seq"
OWNED BY "public"."r_database_contype"."id_database_contype";
SELECT setval('"public"."r_database_contype_id_database_contype_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_database_id_database_seq"
OWNED BY "public"."r_database"."id_database";
SELECT setval('"public"."r_database_id_database_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_database_type_id_database_type_seq"
OWNED BY "public"."r_database_type"."id_database_type";
SELECT setval('"public"."r_database_type_id_database_type_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_dependency_id_dependency_seq"
OWNED BY "public"."r_dependency"."id_dependency";
SELECT setval('"public"."r_dependency_id_dependency_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_directory_id_directory_seq"
OWNED BY "public"."r_directory"."id_directory";
SELECT setval('"public"."r_directory_id_directory_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_element_attribute_id_element_attribute_seq"
OWNED BY "public"."r_element_attribute"."id_element_attribute";
SELECT setval('"public"."r_element_attribute_id_element_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_element_id_element_seq"
OWNED BY "public"."r_element"."id_element";
SELECT setval('"public"."r_element_id_element_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_element_type_id_element_type_seq"
OWNED BY "public"."r_element_type"."id_element_type";
SELECT setval('"public"."r_element_type_id_element_type_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_job_attribute_id_job_attribute_seq"
OWNED BY "public"."r_job_attribute"."id_job_attribute";
SELECT setval('"public"."r_job_attribute_id_job_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_job_hop_id_job_hop_seq"
OWNED BY "public"."r_job_hop"."id_job_hop";
SELECT setval('"public"."r_job_hop_id_job_hop_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_job_id_job_seq"
OWNED BY "public"."r_job"."id_job";
SELECT setval('"public"."r_job_id_job_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_job_lock_id_job_lock_seq"
OWNED BY "public"."r_job_lock"."id_job_lock";
SELECT setval('"public"."r_job_lock_id_job_lock_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_jobentry_attribute_id_jobentry_attribute_seq"
OWNED BY "public"."r_jobentry_attribute"."id_jobentry_attribute";
SELECT setval('"public"."r_jobentry_attribute_id_jobentry_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_jobentry_copy_id_jobentry_copy_seq"
OWNED BY "public"."r_jobentry_copy"."id_jobentry_copy";
SELECT setval('"public"."r_jobentry_copy_id_jobentry_copy_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_jobentry_id_jobentry_seq"
OWNED BY "public"."r_jobentry"."id_jobentry";
SELECT setval('"public"."r_jobentry_id_jobentry_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_jobentry_type_id_jobentry_type_seq"
OWNED BY "public"."r_jobentry_type"."id_jobentry_type";
SELECT setval('"public"."r_jobentry_type_id_jobentry_type_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_log_id_log_seq"
OWNED BY "public"."r_log"."id_log";
SELECT setval('"public"."r_log_id_log_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_loglevel_id_loglevel_seq"
OWNED BY "public"."r_loglevel"."id_loglevel";
SELECT setval('"public"."r_loglevel_id_loglevel_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_namespace_id_namespace_seq"
OWNED BY "public"."r_namespace"."id_namespace";
SELECT setval('"public"."r_namespace_id_namespace_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_note_id_note_seq"
OWNED BY "public"."r_note"."id_note";
SELECT setval('"public"."r_note_id_note_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_partition_id_partition_seq"
OWNED BY "public"."r_partition"."id_partition";
SELECT setval('"public"."r_partition_id_partition_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_partition_schema_id_partition_schema_seq"
OWNED BY "public"."r_partition_schema"."id_partition_schema";
SELECT setval('"public"."r_partition_schema_id_partition_schema_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_repository_log_id_repository_log_seq"
OWNED BY "public"."r_repository_log"."id_repository_log";
SELECT setval('"public"."r_repository_log_id_repository_log_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_slave_id_slave_seq"
OWNED BY "public"."r_slave"."id_slave";
SELECT setval('"public"."r_slave_id_slave_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_step_attribute_id_step_attribute_seq"
OWNED BY "public"."r_step_attribute"."id_step_attribute";
SELECT setval('"public"."r_step_attribute_id_step_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_step_id_step_seq"
OWNED BY "public"."r_step"."id_step";
SELECT setval('"public"."r_step_id_step_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_step_type_id_step_type_seq"
OWNED BY "public"."r_step_type"."id_step_type";
SELECT setval('"public"."r_step_type_id_step_type_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_attribute_id_trans_attribute_seq"
OWNED BY "public"."r_trans_attribute"."id_trans_attribute";
SELECT setval('"public"."r_trans_attribute_id_trans_attribute_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_cluster_id_trans_cluster_seq"
OWNED BY "public"."r_trans_cluster"."id_trans_cluster";
SELECT setval('"public"."r_trans_cluster_id_trans_cluster_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_hop_id_trans_hop_seq"
OWNED BY "public"."r_trans_hop"."id_trans_hop";
SELECT setval('"public"."r_trans_hop_id_trans_hop_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_lock_id_trans_lock_seq"
OWNED BY "public"."r_trans_lock"."id_trans_lock";
SELECT setval('"public"."r_trans_lock_id_trans_lock_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_partition_schema_id_trans_partition_schema_seq"
OWNED BY "public"."r_trans_partition_schema"."id_trans_partition_schema";
SELECT setval('"public"."r_trans_partition_schema_id_trans_partition_schema_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_trans_slave_id_trans_slave_seq"
OWNED BY "public"."r_trans_slave"."id_trans_slave";
SELECT setval('"public"."r_trans_slave_id_trans_slave_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_transformation_id_transformation_seq"
OWNED BY "public"."r_transformation"."id_transformation";
SELECT setval('"public"."r_transformation_id_transformation_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_user_id_user_seq"
OWNED BY "public"."r_user"."id_user";
SELECT setval('"public"."r_user_id_user_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_value_id_value_seq"
OWNED BY "public"."r_value"."id_value";
SELECT setval('"public"."r_value_id_value_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."r_version_id_version_seq"
OWNED BY "public"."r_version"."id_version";
SELECT setval('"public"."r_version_id_version_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."test_product_id_seq"
OWNED BY "public"."test_product"."id";
SELECT setval('"public"."test_product_id_seq"', 342, true);

-- ----------------------------
-- Primary Key structure for table qrtz_blob_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_blob_triggers" ADD CONSTRAINT "qrtz_blob_triggers_pkey" PRIMARY KEY ("sched_name", "trigger_name", "trigger_group");

-- ----------------------------
-- Primary Key structure for table qrtz_calendars
-- ----------------------------
ALTER TABLE "public"."qrtz_calendars" ADD CONSTRAINT "qrtz_calendars_pkey" PRIMARY KEY ("sched_name", "calendar_name");

-- ----------------------------
-- Primary Key structure for table qrtz_cron_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_cron_triggers" ADD CONSTRAINT "qrtz_cron_triggers_pkey" PRIMARY KEY ("sched_name", "trigger_name", "trigger_group");

-- ----------------------------
-- Indexes structure for table qrtz_fired_triggers
-- ----------------------------
CREATE INDEX "idx_qrtz_ft_inst_job_req_rcvry" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "instance_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "requests_recovery" "pg_catalog"."bool_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_ft_j_g" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_ft_jg" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_ft_t_g" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_ft_tg" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_ft_trig_inst_name" ON "public"."qrtz_fired_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "instance_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table qrtz_fired_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_fired_triggers" ADD CONSTRAINT "qrtz_fired_triggers_pkey" PRIMARY KEY ("sched_name", "entry_id");

-- ----------------------------
-- Indexes structure for table qrtz_job_details
-- ----------------------------
CREATE INDEX "idx_qrtz_j_grp" ON "public"."qrtz_job_details" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_j_req_recovery" ON "public"."qrtz_job_details" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "requests_recovery" "pg_catalog"."bool_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table qrtz_job_details
-- ----------------------------
ALTER TABLE "public"."qrtz_job_details" ADD CONSTRAINT "qrtz_job_details_pkey" PRIMARY KEY ("sched_name", "job_name", "job_group");

-- ----------------------------
-- Primary Key structure for table qrtz_locks
-- ----------------------------
ALTER TABLE "public"."qrtz_locks" ADD CONSTRAINT "qrtz_locks_pkey" PRIMARY KEY ("sched_name", "lock_name");

-- ----------------------------
-- Primary Key structure for table qrtz_paused_trigger_grps
-- ----------------------------
ALTER TABLE "public"."qrtz_paused_trigger_grps" ADD CONSTRAINT "qrtz_paused_trigger_grps_pkey" PRIMARY KEY ("sched_name", "trigger_group");

-- ----------------------------
-- Primary Key structure for table qrtz_scheduler_state
-- ----------------------------
ALTER TABLE "public"."qrtz_scheduler_state" ADD CONSTRAINT "qrtz_scheduler_state_pkey" PRIMARY KEY ("sched_name", "instance_name");

-- ----------------------------
-- Primary Key structure for table qrtz_simple_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_simple_triggers" ADD CONSTRAINT "qrtz_simple_triggers_pkey" PRIMARY KEY ("sched_name", "trigger_name", "trigger_group");

-- ----------------------------
-- Primary Key structure for table qrtz_simprop_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_simprop_triggers" ADD CONSTRAINT "qrtz_simprop_triggers_pkey" PRIMARY KEY ("sched_name", "trigger_name", "trigger_group");

-- ----------------------------
-- Indexes structure for table qrtz_triggers
-- ----------------------------
CREATE INDEX "idx_qrtz_t_c" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "calendar_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_g" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_j" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_jg" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_n_g_state" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_n_state" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_next_fire_time" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "next_fire_time" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_nft_misfire" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "misfire_instr" "pg_catalog"."int2_ops" ASC NULLS LAST,
  "next_fire_time" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_nft_st" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "next_fire_time" "pg_catalog"."int8_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_nft_st_misfire" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "misfire_instr" "pg_catalog"."int2_ops" ASC NULLS LAST,
  "next_fire_time" "pg_catalog"."int8_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_nft_st_misfire_grp" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "misfire_instr" "pg_catalog"."int2_ops" ASC NULLS LAST,
  "next_fire_time" "pg_catalog"."int8_ops" ASC NULLS LAST,
  "trigger_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "idx_qrtz_t_state" ON "public"."qrtz_triggers" USING btree (
  "sched_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "trigger_state" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table qrtz_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_triggers" ADD CONSTRAINT "qrtz_triggers_pkey" PRIMARY KEY ("sched_name", "trigger_name", "trigger_group");

-- ----------------------------
-- Indexes structure for table r_database_attribute
-- ----------------------------
CREATE UNIQUE INDEX "idx_rdat" ON "public"."r_database_attribute" USING btree (
  "id_database" "pg_catalog"."int4_ops" ASC NULLS LAST,
  "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_directory
-- ----------------------------
CREATE UNIQUE INDEX "idx_rdir" ON "public"."r_directory" USING btree (
  "id_directory_parent" "pg_catalog"."int4_ops" ASC NULLS LAST,
  "directory_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_job_attribute
-- ----------------------------
CREATE UNIQUE INDEX "idx_jatt" ON "public"."r_job_attribute" USING btree (
  "id_job" "pg_catalog"."int4_ops" ASC NULLS LAST,
  "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "nr" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_jobentry_attribute
-- ----------------------------
CREATE UNIQUE INDEX "idx_rjea" ON "public"."r_jobentry_attribute" USING btree (
  "id_jobentry_attribute" "pg_catalog"."int8_ops" ASC NULLS LAST,
  "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "nr" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_jobentry_database
-- ----------------------------
CREATE INDEX "idx_rjd1" ON "public"."r_jobentry_database" USING btree (
  "id_job" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "idx_rjd2" ON "public"."r_jobentry_database" USING btree (
  "id_database" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_step_attribute
-- ----------------------------
CREATE UNIQUE INDEX "idx_rsat" ON "public"."r_step_attribute" USING btree (
  "id_step" "pg_catalog"."int4_ops" ASC NULLS LAST,
  "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "nr" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_step_database
-- ----------------------------
CREATE INDEX "idx_rsd1" ON "public"."r_step_database" USING btree (
  "id_transformation" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "idx_rsd2" ON "public"."r_step_database" USING btree (
  "id_database" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Indexes structure for table r_trans_attribute
-- ----------------------------
CREATE UNIQUE INDEX "idx_tatt" ON "public"."r_trans_attribute" USING btree (
  "id_transformation" "pg_catalog"."int4_ops" ASC NULLS LAST,
  "code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "nr" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table task_info
-- ----------------------------
ALTER TABLE "public"."task_info" ADD CONSTRAINT "quartz_info_pkey" PRIMARY KEY ("task_id");

-- ----------------------------
-- Primary Key structure for table task_log
-- ----------------------------
ALTER TABLE "public"."task_log" ADD CONSTRAINT "quartz_log_pkey" PRIMARY KEY ("log_id");

-- ----------------------------
-- Primary Key structure for table test_product
-- ----------------------------
ALTER TABLE "public"."test_product" ADD CONSTRAINT "test_product_pk" PRIMARY KEY ("id");

-- ----------------------------
-- Foreign Keys structure for table qrtz_blob_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_blob_triggers" ADD CONSTRAINT "qrtz_blob_triggers_sched_name_trigger_name_trigger_group_fkey" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "public"."qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table qrtz_cron_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_cron_triggers" ADD CONSTRAINT "qrtz_cron_triggers_sched_name_trigger_name_trigger_group_fkey" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "public"."qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table qrtz_simple_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_simple_triggers" ADD CONSTRAINT "qrtz_simple_triggers_sched_name_trigger_name_trigger_group_fkey" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "public"."qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table qrtz_simprop_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_simprop_triggers" ADD CONSTRAINT "qrtz_simprop_triggers_sched_name_trigger_name_trigger_grou_fkey" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "public"."qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table qrtz_triggers
-- ----------------------------
ALTER TABLE "public"."qrtz_triggers" ADD CONSTRAINT "qrtz_triggers_sched_name_job_name_job_group_fkey" FOREIGN KEY ("sched_name", "job_name", "job_group") REFERENCES "public"."qrtz_job_details" ("sched_name", "job_name", "job_group") ON DELETE NO ACTION ON UPDATE NO ACTION;
